|
|
Datamart malých a stredne veľkých podnikov
Balko, Michal
The thesis describes the realization of datamart for small and medium-sized businesses (SMB) in an existing data warehouse environment conforming to Kimball Bus architecture. The introductory section deals with the theoretical guidelines of data warehousing and Business Intelligence. Following with the analysis of the current state of SMB datamart and data warehouse architecture. The results together with business requirements are used for the design of new datamart which encompasses ETL processes, OLTP database, OLAP model and reports. Each of these components are implemented using the tools from Microsoft. Final solution is tested and deployed on the production instance of database server running MS SQL Server.
|
|
|
Evaluation of efficiency of self-service BI implementation in small and medium-sized enterprises
Aleinikova, Aleksandra ; Pour, Jan (advisor) ; Fortinová, Jana (referee)
The main goal of this Bachelor thesis is to evaluate the efficiency of implementation of self-service Business Intelligence (SS BI) in small and medium-sized enterprises (SME). To achieve this goal it is necessary to define essences of BI and SS BI, evaluate the relation between SME and BI, and assess possibilities of SS BI in case of enterprise, which specializes on fermented milk products. The theoretical part of this thesis explains methodology behind BI and SS BI, and emphasizes the definition of SME. The practical part provides the description of the small enterprise called Lakto and analyses the implementation of the prototype of SS BI solution in this company. In addition, the practical part provides visualization of results using Qlik Sense Desktop tool. The main contribution of this thesis is assessment of self-service BI implementation in SME and discussion of its main benefits.
|
|
|
Pilot implementation of Business Intelligence in a retail company
Savka, Ján ; Novotný, Ota (advisor) ; Matějka, Martin (referee)
The thesis focuses on implementation of Business Intelligence in a small retail company. The aim of the thesis is to design a pilot Business Intelligence solution to support management activities in Lintea, s. r. o. The company is part of Slovak lingerie and underwear retail market since 2004. Business performance measurement is not effectively supported in the company. Rise in the quality level of management activities is the main benefit of the proposed implementation which is achieved by delivering previously inaccessible or laboriously accessible information in an appropriate form. Proposed solution substantially simplifies, accelerates and improves management and decision making activities in the company. Thesis has two parts: theoretical and practical. Theoretical part has two chapters devoted to performance management and BI. Chapter about performance management presents wider aspects of using BI in companies and introduces the Balanced Scorecard method. Chapter about Business Intelligence defines BI, explains its principles, components and basic analytic method of BI - the dimensional modelling which is then applied in the practical part. The theoretical part ends with the description of current situation in the BI market. The practical part starts with the introduction of the company Lintea, s. r. o. followed by the description of its current state and proposal of the business performance measures based on the Balanced Scorecard method. Second chapter of the practical part contains the proposed Business Intelligence solution itself. Individual steps of the Business Intelligence design process are: analysis of prerequisites and requirements, analysis of data sources, dimensional modelling, ETL design, multidimensional data structures design and finally presentation layer design.
|
|
|
Business Intelligence solutions in a company Topaz
Kochkonyan, Gretta ; Pour, Jan (advisor) ; Fortinová, Jana (referee)
The main objective of this bachelor thesis is to analyze the business environment of the company Topaz and to design a BI solution prototype based on this analysis and requirements of company. The solution will be used in subsequent support for the managerial decisions of the business owner. The necessary condition for fulfilling the objective of this thesis was the access to the in-formation system of the company and to the data that were used as a basis for the analysis and design of the Business Intelligence solution. Access to the IS and its data has been granted by the owner of the company Topaz. The work is divided into theoretical part, which describes the basic characteristics of BI, or the Self-Service BI respectively, and to the practical part, where the running of the company is described with an emphasis on the support of an established information system. Then, an initial study is conducted, including requirements, with which the dimensional model is made. Finally, samples of the respective reports are presented.
|
|
|
Possibilities of using Business Intelligence in a medium-sized logistics company
Šarišský, Jakub ; Šperková, Lucie (advisor) ; Daněk, Lukáš (referee)
The main objective of bachelor thesis is examination of the current work with data and its interpretation the medium-sized logistics company and analysis of the benefits of deployment of Business Intelligence solutions in general terms but also directly in company called Zásilkovna s.r.o. This thesis emphasis on user requirements and provides a direct example of the usage of BI. The basis for the solution are theoretical knowledge in the field of BI, analysis of user requirements and experiences gained during working in the company. The work is divided into theoretical part in which is presented the issue of BI and advantages / disadvantages of deployed solutions. The practical part analyze current situation in the company. It is preparing documents for the BI solution through dimensional modeling and presents practical possibilities of BI in the companyand offers benefits and threats of BI solutions. The main contribution of this project is to evaluate how a medium sized company is able to use BI. Main contributions for Zásilkovna are exaples of outputs and benefits of BI directly in the company environment.
|
|
|
Analysis and Design Business Intelligence solutions for ATOZ group
Machaj, Maroš ; Pour, Jan (advisor) ; Horníček, Martin (referee)
The main objective of this work will be the analysis of BI solution for this company, which deals with the publication of professional journals and the organization of conferences. BI solution should be used by company management. In order to achieve the objective of this work it was necessary to contact the company with IT professionals and employees who have access to the IS company. It was also necessary to consult the requirements for BI solutions for a company with a higher-ranking employees of the company. Thanks to these consultations it was possible to create the skeleton for the analysis of the company and on these grounds the new key indicators were created. To these indicators then new dimensions were added as well. The practical part consists of two parts, namely the analysis of a specific BI solution for the company. The work will include a small sample of BI solution for BI benefits. This solution includes designing the data warehouse, ETL and pilot solution. The contribution of this work is to design BI for publishing (advertising) company. The company is quite specific, so another company for which it would be suitable as well, is difficult to find.
|
|
|
Analysis and proposal of Business Intelligence for ZVL AUTO s.r.o.
Ligus, Slavomír ; Pour, Jan (advisor) ; Prokopovič, Tomáš (referee)
The main objective of this bachelor thesis is to analyse the environment of the production company ZVL auto s.r.o. and to suggest and realize a model solution in the field of Business Intelligence based on this analysis. Thesis is divided into two parts. The first part contains a brief description of components that Business Intelligence consists of and the analysis of the company's environment. In the second part, there is the initial analysis, data model that was created, and an example of a model solution created based on the analysis of the company. The added value of this thesis is to demonstrate and introduce the possibilities and advantages of Business Intelligence usage to the company's management, and possibly to motivate the company to implement a complete solution in the future.
|
|
|
Analysis and design of a prototypical Business Intelligence solution for a chosen Company
Straka, Radim ; Pour, Jan (advisor) ; Klíma, Vladimír (referee)
The main purpose of this bachelor thesis is an analysis and design of a prototypical Business Intelligence solution for a company called KMPS, with a focus on a financial area. The solution is based on the complex analysis containing a general analysis of the company, requirements of the company and an analysis of source data. The application was created with a Self Service BI tool called Power Pivot. Since the company has not yet have established any similar system, the application is designed in accordance with needs of the company in a way that management and the economical department of the company can actively use the application afterwards. The thesis consists of two parts. The first theoretical part deals with general terms and definitions of a BI area. The second practical part describes all performed operations which led to the BI solution.
|
|
|
Analysis and design of Business Intelligence solution for Automotive Lighting s.r.o.
Miksová, Michaela ; Pour, Jan (advisor) ; Fortinová, Jana (referee)
The main purpose of the bachelor thesis is to analyze a manufacturing plant and to design a Business Intelligence solution for its assembly department. In the first part I focus on a detailed description of business processes in the department. The second part is devoted to the initial study, which means processing of the users' requests, designing a dimensional model, mapping available resources including an analysis of them, and preparation of a data model of a data mart. The last part consists of a report framework.
|
|
|
Analytické úlohy v business intelligence
Šindelář, Radek ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
The main aim of this bachelor thesis is the analysis and design of business intelligence solution in chosen company engaged by the automotive industry. The work is divided into two parts. The theoretical part includes the idea and mission of the dimensional modeling. The practical part involves implementation into practical solution of business intelligence to fulfill their functions. We will fulfill introduction of business intelligence on the basis of ordering document a data base, which we have got. From the base point of view is possible to realize business intelligence solution in the form that will suit to target users. It is possible to display data at a level and in such form, that the company will suit from to point of economic and user perspective view.
|
guest ::
